<?php

if (!defined('BASEPATH'))
    exit('No direct script access allowed');

class Welcome extends CI_Controller
{

    /**
     * Index Page for this controller.
     *
     * Maps to the following URL
     * 		http://example.com/index.php/welcome
     *	- or -  
     * 		http://example.com/index.php/welcome/index
     *	- or -
     * Since this controller is set as the default controller in 
     * config/routes.php, it's displayed at http://example.com/
     *
     * So any other public methods not prefixed with an underscore will
     * map to /index.php/welcome/<method_name>
     * @see http://codeigniter.com/user_guide/general/urls.html
     */

    public function index()
    {
        $this->load->helper('text');
        $table = 'doc_documents';
        $sql = "SELECT * FROM $table";
        $query = $this->db->query($sql);
        foreach ($query->result() as $row) {
            $title = iurl_title($row->title).'-'.date('y-m-d', $row->created);
            $arr['alias'] = $title;
            $this->db->update("$table", $arr, array('id' => $row->id));
        }
       
    }
}

    /* End of file welcome.php */
    /* Location: ./application/controllers/welcome.php */
